package com.transaction.simulate.mapper;


import com.transaction.simulate.model.dto.Interface;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

public interface InterFaceMapper {

    @Select("SELECT * FROM t_interface t WHERE t.interfaceCode = #{interfaceCode} ORDER BY colCode")
    List<Interface> selectInterfaceByCode(@Param("interfaceCode") String interfaceCode);

    @Select("SELECT UPPER(t.colEnName) column_name ,t.colCnName column_comment  FROM t_interface t WHERE t.interfaceCode = #{interfaceCode} ORDER BY colCode")
    List<Map<String, String>> selectInterfaceMapByCode(@Param("interfaceCode")String interfaceCode);
}
